<?php

$opts['tb'] = $PACTS_cfg->educationgradetablename;

// Name of field which is the unique key
$opts['key'] = 'EducationGrade';

// Type of key field (int/real/string/date etc.)
$opts['key_type'] = 'string';

// Sorting field(s)
$opts['sort_field'] = array('YearCount','YearCountOperator');

// users can not edit or add
$opts['options'] = 'VF';


$opts['fdd']['EducationGrade'] = array(
  'name'     => 'EducationGrade',
  'select'   => 'T',
  'maxlen'   => 10,
  'default'  => '',
  'required' => true,
  'sort'     => true
);
$opts['fdd']['Description'] = array(
  'name'     => 'Description',
  'select'   => 'T',
  'maxlen'   => 50,
  'sort'     => true
);
$opts['fdd']['YearCount'] = array(
  'name'     => 'YearCount',
  'select'   => 'T',
  'maxlen'   => 3,
  'required' => true,
  'sort'     => true
);
$opts['fdd']['YearCountOperator'] = array(
  'name'     => 'YearCountOperator',
  'select'   => 'T',
  'maxlen'   => 1,
  'required' => true,
  'sort'     => true,
  'values'   => array('<','=','>')

);

// Now important call to phpMyEdit
new phpMyEdit($opts);

?>

